[dbo].[Microsite]

SQLServer > iMIS1521GA > Tables > dbo.Microsite

Properties
Columns
Permissions
SQL Script
Uses
Used By

Property	Value
Heap
Created	10:31:27 AM Tuesday, March 02, 2010
Last Modified	10:31:27 AM Tuesday, March 02, 2010

Columns

Name	Data Type	Max Length (Bytes)	Allow Nulls
MicrositeID	numeric(18,0)	9
HomeNavMenuID	numeric(18,0)	9

Permissions

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

SQL Script

CREATE TABLE [dbo].[Microsite]
(
[MicrositeID] [numeric] (18, 0) NULL,
[HomeNavMenuID] [numeric] (18, 0) NULL
) ON [PRIMARY]

GO
GRANT REFERENCES ON  [dbo].[Microsite] TO [IMIS]
GRANT SELECT ON  [dbo].[Microsite] TO [IMIS]
GRANT INSERT ON  [dbo].[Microsite] TO [IMIS]
GRANT DELETE ON  [dbo].[Microsite] TO [IMIS]
GRANT UPDATE ON  [dbo].[Microsite] TO [IMIS]
GO

Uses

Used By

[dbo].[amsp_GetSearchableComponents]